Airbnb Booking

Dataset statistics

Number of variables	30
Number of observations	546589
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	82354
Duplicate rows (%)	15.1%
Total size in memory	125.1 MiB
Average record size in memory	240.0 B

Variable types

Numeric	19
Categorical	11

Alerts

Dataset has 82354 (15.1%) duplicate rows	Duplicates
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 1 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 1 other fields	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`affiliate_channel` is highly correlated with `affiliate_provider`	High correlation
`signup_app` is highly correlated with `first_device_type`	High correlation
`affiliate_provider` is highly correlated with `affiliate_channel`	High correlation
`first_browser` is highly correlated with `first_device_type`	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 3 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 5 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`year_first_active` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`month_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`day_first_booking` is highly correlated with `days_from_first_active_until_booking` and 6 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 9 other fields	High correlation
`year_account_created` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 1 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`country_destination` is highly correlated with `days_from_first_active_until_booking` and 4 other fields	High correlation
`days_from_first_active_until_account_created` is highly skewed (γ1 = 68.33411796)	Skewed
`signup_flow` has 437533 (80.0%) zeros	Zeros
`days_from_first_active_until_booking` has 122273 (22.4%) zeros	Zeros
`days_from_first_active_until_account_created` has 545580 (99.8%) zeros	Zeros
`days_from_account_created_until_first_booking` has 122162 (22.3%) zeros	Zeros
`day_of_week_first_active` has 88730 (16.2%) zeros	Zeros
`day_of_week_first_booking` has 124318 (22.7%) zeros	Zeros
`day_of_week_account_created` has 88683 (16.2%) zeros	Zeros

Reproduction

Analysis started	2022-02-01 22:34:27.341769
Analysis finished	2022-02-01 22:39:49.294876
Duration	5 minutes and 21.95 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.753039304

Minimum	0
Maximum	25
Zeros	437533
Zeros (%)	80.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	15
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.368695707
Coefficient of variation (CV)	3.062507324
Kurtosis	11.12837096
Mean	1.753039304
Median Absolute Deviation (MAD)	0
Skewness	3.482994472
Sum	958192
Variance	28.82289359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	437533	80.0%
1	25194	4.6%
2	21957	4.0%
25	11726	2.1%
3	10882	2.0%
12	8554	1.6%
24	6951	1.3%
23	2977	0.5%
5	1984	0.4%
4	1910	0.3%
Other values (16)	16921	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	437533	80.0%
1	25194	4.6%
2	21957	4.0%
3	10882	2.0%
4	1910	0.3%
5	1984	0.4%
6	1906	0.3%
7	1632	0.3%
8	1707	0.3%
9	1570	0.3%

Value	Count	Frequency (%)
25	11726	2.1%
24	6951	1.3%
23	2977	0.5%
22	790	0.1%
21	1023	0.2%
20	646	0.1%
19	676	0.1%
18	634	0.1%
17	669	0.1%
16	603	0.1%

days_from_first_active_until_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1853
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.4395515

Minimum	0
Maximum	2228
Zeros	122273
Zeros (%)	22.4%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	105
95-th percentile	675
Maximum	2228
Range	2228
Interquartile range (IQR)	104

Descriptive statistics

Standard deviation	241.5053925
Coefficient of variation (CV)	2.074083844
Kurtosis	9.694032896
Mean	116.4395515
Median Absolute Deviation (MAD)	6
Skewness	2.961521664
Sum	63644578
Variance	58324.85462
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122273	22.4%
1	68401	12.5%
2	30714	5.6%
3	19613	3.6%
4	14604	2.7%
5	11272	2.1%
6	10294	1.9%
7	9087	1.7%
8	7969	1.5%
9	6319	1.2%
Other values (1843)	246043	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122273	22.4%
1	68401	12.5%
2	30714	5.6%
3	19613	3.6%
4	14604	2.7%
5	11272	2.1%
6	10294	1.9%
7	9087	1.7%
8	7969	1.5%
9	6319	1.2%

Value	Count	Frequency (%)
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%

days_from_first_active_until_account_created
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	326
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2252204124

Minimum	0
Maximum	1456
Zeros	545580
Zeros (%)	99.8%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.1769148
Coefficient of variation (CV)	45.18646729
Kurtosis	5833.323547
Mean	0.2252204124
Median Absolute Deviation (MAD)	0
Skewness	68.33411796
Sum	123103
Variance	103.5695948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	545580	99.8%
1	95	< 0.1%
2	94	< 0.1%
4	78	< 0.1%
3	61	< 0.1%
5	18	< 0.1%
6	14	< 0.1%
13	12	< 0.1%
29	10	< 0.1%
10	9	< 0.1%
Other values (316)	618	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	545580	99.8%
1	95	< 0.1%
2	94	< 0.1%
3	61	< 0.1%
4	78	< 0.1%
5	18	< 0.1%
6	14	< 0.1%
7	5	< 0.1%
8	4	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1011	1	< 0.1%
1006	1	< 0.1%
991	1	< 0.1%
984	1	< 0.1%
968	1	< 0.1%

days_from_account_created_until_first_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1968
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.2138627

Minimum	-349
Maximum	2001
Zeros	122162
Zeros (%)	22.3%
Negative	230
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	1
median	6
Q3	104
95-th percentile	673
Maximum	2001
Range	2350
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	241.2466
Coefficient of variation (CV)	2.075884877
Kurtosis	9.708491478
Mean	116.2138627
Median Absolute Deviation (MAD)	6
Skewness	2.963440907
Sum	63521219
Variance	58199.92203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122162	22.3%
1	68396	12.5%
2	30706	5.6%
3	19600	3.6%
4	14596	2.7%
5	11278	2.1%
6	10303	1.9%
7	9088	1.7%
8	7970	1.5%
9	6321	1.2%
Other values (1958)	246169	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	1	< 0.1%
-295	1	< 0.1%
-288	1	< 0.1%
-273	1	< 0.1%
-269	1	< 0.1%
-261	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%
1976	1	< 0.1%

year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.712358

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2013
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.93452385
Coefficient of variation (CV)	0.0004643106832
Kurtosis	-0.311298521
Mean	2012.712358
Median Absolute Deviation (MAD)	1
Skewness	-0.3969496091
Sum	1100126435
Variance	0.8733348262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	220917	40.4%
2012	155715	28.5%
2014	114921	21.0%
2011	48689	8.9%
2010	6338	1.2%
2009	9	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6338	1.2%
2011	48689	8.9%
2012	155715	28.5%
2013	220917	40.4%
2014	114921	21.0%

Value	Count	Frequency (%)
2014	114921	21.0%
2013	220917	40.4%
2012	155715	28.5%
2011	48689	8.9%
2010	6338	1.2%
2009	9	< 0.1%

month_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.845787237

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.073523256
Coefficient of variation (CV)	0.5257672118
Kurtosis	-0.8691152425
Mean	5.845787237
Median Absolute Deviation (MAD)	2
Skewness	0.2690725303
Sum	3195243
Variance	9.446545208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	73322	13.4%
6	72190	13.2%
4	60296	11.0%
3	51509	9.4%
2	44391	8.1%
8	43897	8.0%
1	42469	7.8%
9	40752	7.5%
7	33502	6.1%
11	32365	5.9%
Other values (2)	51896	9.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42469	7.8%
2	44391	8.1%
3	51509	9.4%
4	60296	11.0%
5	73322	13.4%
6	72190	13.2%
7	33502	6.1%
8	43897	8.0%
9	40752	7.5%
10	31347	5.7%

Value	Count	Frequency (%)
12	20549	3.8%
11	32365	5.9%
10	31347	5.7%
9	40752	7.5%
8	43897	8.0%
7	33502	6.1%
6	72190	13.2%
5	73322	13.4%
4	60296	11.0%
3	51509	9.4%

day_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.53396977

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.483375634
Coefficient of variation (CV)	0.5461176867
Kurtosis	-1.180670619
Mean	15.53396977
Median Absolute Deviation (MAD)	7
Skewness	-0.008603738253
Sum	8490697
Variance	71.96766214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	19908	3.6%
22	19863	3.6%
23	19801	3.6%
3	19710	3.6%
16	19576	3.6%
13	19111	3.5%
15	19109	3.5%
21	18991	3.5%
25	18955	3.5%
9	18934	3.5%
Other values (21)	352631	64.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13943	2.6%
2	17015	3.1%
3	19710	3.6%
4	18199	3.3%
5	18502	3.4%
6	18108	3.3%
7	17957	3.3%
8	17629	3.2%
9	18934	3.5%
10	18575	3.4%

Value	Count	Frequency (%)
31	3149	0.6%
30	11892	2.2%
29	15459	2.8%
28	17790	3.3%
27	18683	3.4%
26	18004	3.3%
25	18955	3.5%
24	19908	3.6%
23	19801	3.6%
22	19863	3.6%

day_of_week_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.463664655

Minimum	0
Maximum	6
Zeros	88730
Zeros (%)	16.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.763879644
Coefficient of variation (CV)	0.7159576856
Kurtosis	-0.9596877006
Mean	2.463664655
Median Absolute Deviation (MAD)	1
Skewness	0.2637619426
Sum	1346612
Variance	3.1112714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	102872	18.8%
1	100314	18.4%
3	90857	16.6%
0	88730	16.2%
4	77668	14.2%
5	59577	10.9%
6	26571	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	88730	16.2%
1	100314	18.4%
2	102872	18.8%
3	90857	16.6%
4	77668	14.2%
5	59577	10.9%
6	26571	4.9%

Value	Count	Frequency (%)
6	26571	4.9%
5	59577	10.9%
4	77668	14.2%
3	90857	16.6%
2	102872	18.8%
1	100314	18.4%
0	88730	16.2%

week_of_year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.07136258

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.34587645
Coefficient of variation (CV)	0.5544296217
Kurtosis	-0.8740536789
Mean	24.07136258
Median Absolute Deviation (MAD)	10
Skewness	0.2717954675
Sum	13157142
Variance	178.1124182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18255	3.3%
19	17720	3.2%
26	17653	3.2%
21	17003	3.1%
25	16966	3.1%
24	16352	3.0%
20	16064	2.9%
18	15936	2.9%
22	15825	2.9%
17	14771	2.7%
Other values (43)	380044	69.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6036	1.1%
2	6636	1.2%
3	10094	1.8%
4	9796	1.8%
5	9321	1.7%
6	11131	2.0%
7	11416	2.1%
8	11607	2.1%
9	11654	2.1%
10	11560	2.1%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3683	0.7%
51	5224	1.0%
50	6410	1.2%
49	7148	1.3%
48	6337	1.2%
47	7444	1.4%
46	8153	1.5%
45	7938	1.5%
44	6734	1.2%

year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.022134

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.115754825
Coefficient of variation (CV)	0.0005542685331
Kurtosis	-0.3775269155
Mean	2013.022134
Median Absolute Deviation (MAD)	1
Skewness	-0.03286890093
Sum	1100295755
Variance	1.24490883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	199469	36.5%
2012	130447	23.9%
2014	114063	20.9%
2015	59714	10.9%
2011	37742	6.9%
2010	5154	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	5154	0.9%
2011	37742	6.9%
2012	130447	23.9%
2013	199469	36.5%
2014	114063	20.9%
2015	59714	10.9%

Value	Count	Frequency (%)
2015	59714	10.9%
2014	114063	20.9%
2013	199469	36.5%
2012	130447	23.9%
2011	37742	6.9%
2010	5154	0.9%

month_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.935291416

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.799557088
Coefficient of variation (CV)	0.4716798034
Kurtosis	-0.5787099636
Mean	5.935291416
Median Absolute Deviation (MAD)	2
Skewness	0.2083893141
Sum	3244165
Variance	7.837519891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	122766	22.5%
5	66253	12.1%
4	50446	9.2%
3	44863	8.2%
8	43064	7.9%
7	40826	7.5%
2	38710	7.1%
9	37789	6.9%
1	31360	5.7%
10	29336	5.4%
Other values (2)	41176	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	31360	5.7%
2	38710	7.1%
3	44863	8.2%
4	50446	9.2%
5	66253	12.1%
6	122766	22.5%
7	40826	7.5%
8	43064	7.9%
9	37789	6.9%
10	29336	5.4%

Value	Count	Frequency (%)
12	14460	2.6%
11	26716	4.9%
10	29336	5.4%
9	37789	6.9%
8	43064	7.9%
7	40826	7.5%
6	122766	22.5%
5	66253	12.1%
4	50446	9.2%
3	44863	8.2%

day_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.58152469

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	17
Q3	25
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.958689144
Coefficient of variation (CV)	0.5402813861
Kurtosis	-1.256949852
Mean	16.58152469
Median Absolute Deviation (MAD)	8
Skewness	-0.08979162464
Sum	9063279
Variance	80.25811117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	67119	12.3%
16	18084	3.3%
5	18056	3.3%
15	18024	3.3%
17	17670	3.2%
23	17623	3.2%
25	17590	3.2%
13	17406	3.2%
3	17321	3.2%
24	17269	3.2%
Other values (21)	320427	58.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14121	2.6%
2	15778	2.9%
3	17321	3.2%
4	17184	3.1%
5	18056	3.3%
6	16372	3.0%
7	15881	2.9%
8	16127	3.0%
9	17022	3.1%
10	16791	3.1%

Value	Count	Frequency (%)
31	2491	0.5%
30	8298	1.5%
29	67119	12.3%
28	13906	2.5%
27	14872	2.7%
26	15895	2.9%
25	17590	3.2%
24	17269	3.2%
23	17623	3.2%
22	17233	3.2%

day_of_week_first_booking
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.219698896

Minimum	0
Maximum	6
Zeros	124318
Zeros (%)	22.7%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.767131882
Coefficient of variation (CV)	0.7961133309
Kurtosis	-0.954287603
Mean	2.219698896
Median Absolute Deviation (MAD)	1
Skewness	0.3454552419
Sum	1213263
Variance	3.122755088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	124318	22.7%
2	97377	17.8%
1	93945	17.2%
3	88408	16.2%
4	72152	13.2%
5	51602	9.4%
6	18787	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	124318	22.7%
1	93945	17.2%
2	97377	17.8%
3	88408	16.2%
4	72152	13.2%
5	51602	9.4%
6	18787	3.4%

Value	Count	Frequency (%)
6	18787	3.4%
5	51602	9.4%
4	72152	13.2%
3	88408	16.2%
2	97377	17.8%
1	93945	17.2%
0	124318	22.7%

week_of_year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.69882672

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	25
Q3	33
95-th percentile	47
Maximum	52
Range	51
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.21603757
Coefficient of variation (CV)	0.4945999137
Kurtosis	-0.6195009967
Mean	24.69882672
Median Absolute Deviation (MAD)	9
Skewness	0.1553782912
Sum	13500107
Variance	149.2315738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	66303	12.1%
24	17041	3.1%
23	16357	3.0%
21	15943	2.9%
25	15611	2.9%
26	15402	2.8%
19	14974	2.7%
20	14915	2.7%
18	13839	2.5%
22	13794	2.5%
Other values (42)	342410	62.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4267	0.8%
2	4982	0.9%
3	7836	1.4%
4	7929	1.5%
5	7042	1.3%
6	8820	1.6%
7	9669	1.8%
8	10171	1.9%
9	10373	1.9%
10	10173	1.9%

Value	Count	Frequency (%)
52	2421	0.4%
51	3809	0.7%
50	4866	0.9%
49	5606	1.0%
48	5291	1.0%
47	6047	1.1%
46	6404	1.2%
45	6877	1.3%
44	5620	1.0%
43	5899	1.1%

year_account_created
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

2013	220969
2012	155725
2014	114960
2011	48632
2010	6303

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2186356
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2011
2nd row	2010
3rd row	2011
4th row	2010
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	220969	40.4%
2012	155725	28.5%
2014	114960	21.0%
2011	48632	8.9%
2010	6303	1.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2013	220969	40.4%
2012	155725	28.5%
2014	114960	21.0%
2011	48632	8.9%
2010	6303	1.2%

Most occurring characters

Value	Count	Frequency (%)
2	702314	32.1%
1	595221	27.2%
0	552892	25.3%
3	220969	10.1%
4	114960	5.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2186356	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	702314	32.1%
1	595221	27.2%
0	552892	25.3%
3	220969	10.1%
4	114960	5.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2186356	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	702314	32.1%
1	595221	27.2%
0	552892	25.3%
3	220969	10.1%
4	114960	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2186356	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	702314	32.1%
1	595221	27.2%
0	552892	25.3%
3	220969	10.1%
4	114960	5.3%

month_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.846992896

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.074223631
Coefficient of variation (CV)	0.5257785815
Kurtosis	-0.8702109257
Mean	5.846992896
Median Absolute Deviation (MAD)	2
Skewness	0.2683999495
Sum	3195902
Variance	9.450850933
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	73316	13.4%
6	72140	13.2%
4	60235	11.0%
3	51488	9.4%
2	44380	8.1%
8	43898	8.0%
1	42488	7.8%
9	40746	7.5%
7	33520	6.1%
11	32404	5.9%
Other values (2)	51974	9.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42488	7.8%
2	44380	8.1%
3	51488	9.4%
4	60235	11.0%
5	73316	13.4%
6	72140	13.2%
7	33520	6.1%
8	43898	8.0%
9	40746	7.5%
10	31420	5.7%

Value	Count	Frequency (%)
12	20554	3.8%
11	32404	5.9%
10	31420	5.7%
9	40746	7.5%
8	43898	8.0%
7	33520	6.1%
6	72140	13.2%
5	73316	13.4%
4	60235	11.0%
3	51488	9.4%

day_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.53595297

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.484583055
Coefficient of variation (CV)	0.5461256911
Kurtosis	-1.181142689
Mean	15.53595297
Median Absolute Deviation (MAD)	7
Skewness	-0.009014229623
Sum	8491781
Variance	71.98814961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	19936	3.6%
22	19880	3.6%
23	19783	3.6%
3	19712	3.6%
16	19602	3.6%
15	19106	3.5%
13	19096	3.5%
21	18981	3.5%
25	18964	3.5%
9	18944	3.5%
Other values (21)	352585	64.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13947	2.6%
2	17018	3.1%
3	19712	3.6%
4	18204	3.3%
5	18497	3.4%
6	18107	3.3%
7	17958	3.3%
8	17613	3.2%
9	18944	3.5%
10	18593	3.4%

Value	Count	Frequency (%)
31	3148	0.6%
30	11883	2.2%
29	15456	2.8%
28	17840	3.3%
27	18697	3.4%
26	18019	3.3%
25	18964	3.5%
24	19936	3.6%
23	19783	3.6%
22	19880	3.6%

day_of_week_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.46403056

Minimum	0
Maximum	6
Zeros	88683
Zeros (%)	16.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.764129836
Coefficient of variation (CV)	0.7159529042
Kurtosis	-0.9603168888
Mean	2.46403056
Median Absolute Deviation (MAD)	1
Skewness	0.2638651793
Sum	1346812
Variance	3.112154077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	102937	18.8%
1	100355	18.4%
3	90710	16.6%
0	88683	16.2%
4	77648	14.2%
5	59675	10.9%
6	26581	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	88683	16.2%
1	100355	18.4%
2	102937	18.8%
3	90710	16.6%
4	77648	14.2%
5	59675	10.9%
6	26581	4.9%

Value	Count	Frequency (%)
6	26581	4.9%
5	59675	10.9%
4	77648	14.2%
3	90710	16.6%
2	102937	18.8%
1	100355	18.4%
0	88683	16.2%

week_of_year_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.07720426

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.34976108
Coefficient of variation (CV)	0.5544564449
Kurtosis	-0.8753488904
Mean	24.07720426
Median Absolute Deviation (MAD)	10
Skewness	0.2711956554
Sum	13160335
Variance	178.2161208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18252	3.3%
19	17704	3.2%
26	17641	3.2%
21	17006	3.1%
25	16963	3.1%
24	16349	3.0%
20	16054	2.9%
18	15934	2.9%
22	15830	2.9%
17	14764	2.7%
Other values (43)	380092	69.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6038	1.1%
2	6636	1.2%
3	10095	1.8%
4	9794	1.8%
5	9330	1.7%
6	11135	2.0%
7	11419	2.1%
8	11602	2.1%
9	11652	2.1%
10	11557	2.1%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3684	0.7%
51	5225	1.0%
50	6411	1.2%
49	7150	1.3%
48	6339	1.2%
47	7484	1.4%
46	8172	1.5%
45	7947	1.5%
44	6755	1.2%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

FEMALE	243928
MALE	215761
-unknown-	85272
OTHER	1628

Length

Max length	9
Median length	6
Mean length	5.675562443
Min length	4

Characters and Unicode

Total characters	3102200
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MALE
2nd row	FEMALE
3rd row	FEMALE
4th row	-unknown-
5th row	FEMALE

Common Values

Value	Count	Frequency (%)
FEMALE	243928	44.6%
MALE	215761	39.5%
-unknown-	85272	15.6%
OTHER	1628	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
female	243928	44.6%
male	215761	39.5%
unknown	85272	15.6%
other	1628	0.3%

Most occurring characters

Value	Count	Frequency (%)
E	705245	22.7%
M	459689	14.8%
A	459689	14.8%
L	459689	14.8%
n	255816	8.2%
F	243928	7.9%
-	170544	5.5%
u	85272	2.7%
k	85272	2.7%
o	85272	2.7%
Other values (5)	91784	3.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2334752	75.3%
Lowercase Letter	596904	19.2%
Dash Punctuation	170544	5.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	705245	30.2%
M	459689	19.7%
A	459689	19.7%
L	459689	19.7%
F	243928	10.4%
O	1628	0.1%
T	1628	0.1%
H	1628	0.1%
R	1628	0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	255816	42.9%
u	85272	14.3%
k	85272	14.3%
o	85272	14.3%
w	85272	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	170544	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2931656	94.5%
Common	170544	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	705245	24.1%
M	459689	15.7%
A	459689	15.7%
L	459689	15.7%
n	255816	8.7%
F	243928	8.3%
u	85272	2.9%
k	85272	2.9%
o	85272	2.9%
w	85272	2.9%
Other values (4)	6512	0.2%

Common

Value	Count	Frequency (%)
-	170544	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3102200	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	705245	22.7%
M	459689	14.8%
A	459689	14.8%
L	459689	14.8%
n	255816	8.2%
F	243928	7.9%
-	170544	5.5%
u	85272	2.7%
k	85272	2.7%
o	85272	2.7%
Other values (5)	91784	3.0%

age
Real number (ℝ_≥0)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.41448694

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	28
median	34
Q3	43
95-th percentile	63
Maximum	115
Range	99
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	14.0232941
Coefficient of variation (CV)	0.3748092049
Kurtosis	5.967223222
Mean	37.41448694
Median Absolute Deviation (MAD)	6
Skewness	2.001328988
Sum	20450347
Variance	196.6527775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	27920	5.1%
32	27119	5.0%
31	27036	4.9%
29	26706	4.9%
28	23883	4.4%
34	23132	4.2%
33	22934	4.2%
27	22132	4.0%
35	20305	3.7%
26	19312	3.5%
Other values (89)	306110	56.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	83	< 0.1%
18	3425	0.6%
19	6528	1.2%
20	1562	0.3%
21	5641	1.0%
22	9680	1.8%
23	11995	2.2%
24	14847	2.7%
25	19236	3.5%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	391	0.1%
109	35	< 0.1%
108	15	< 0.1%
107	23	< 0.1%
106	25	< 0.1%
105	6038	1.1%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

basic	343893
facebook	202184
google	512

Length

Max length	8
Median length	5
Mean length	6.110640719
Min length	5

Characters and Unicode

Total characters	3340009
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	basic
3rd row	facebook
4th row	basic
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	343893	62.9%
facebook	202184	37.0%
google	512	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
basic	343893	62.9%
facebook	202184	37.0%
google	512	0.1%

Most occurring characters

Value	Count	Frequency (%)
b	546077	16.3%
a	546077	16.3%
c	546077	16.3%
o	405392	12.1%
s	343893	10.3%
i	343893	10.3%
e	202696	6.1%
f	202184	6.1%
k	202184	6.1%
g	1024	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3340009	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
b	546077	16.3%
a	546077	16.3%
c	546077	16.3%
o	405392	12.1%
s	343893	10.3%
i	343893	10.3%
e	202696	6.1%
f	202184	6.1%
k	202184	6.1%
g	1024	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3340009	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
b	546077	16.3%
a	546077	16.3%
c	546077	16.3%
o	405392	12.1%
s	343893	10.3%
i	343893	10.3%
e	202696	6.1%
f	202184	6.1%
k	202184	6.1%
g	1024	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3340009	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	546077	16.3%
a	546077	16.3%
c	546077	16.3%
o	405392	12.1%
s	343893	10.3%
i	343893	10.3%
e	202696	6.1%
f	202184	6.1%
k	202184	6.1%
g	1024	< 0.1%

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

en	531847
fr	3522
es	2482
de	2267
zh	1742
Other values (20)	4729

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1093178
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	531847	97.3%
fr	3522	0.6%
es	2482	0.5%
de	2267	0.4%
zh	1742	0.3%
it	1044	0.2%
ko	903	0.2%
ru	716	0.1%
nl	388	0.1%
pt	358	0.1%
Other values (15)	1320	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	531847	97.3%
fr	3522	0.6%
es	2482	0.5%
de	2267	0.4%
zh	1742	0.3%
it	1044	0.2%
ko	903	0.2%
ru	716	0.1%
nl	388	0.1%
pt	358	0.1%
Other values (15)	1320	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	536692	49.1%
n	532324	48.7%
r	4346	0.4%
f	3550	0.3%
s	2848	0.3%
d	2400	0.2%
h	1778	0.2%
z	1742	0.2%
t	1525	0.1%
i	1098	0.1%
Other values (9)	4875	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1093178	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	536692	49.1%
n	532324	48.7%
r	4346	0.4%
f	3550	0.3%
s	2848	0.3%
d	2400	0.2%
h	1778	0.2%
z	1742	0.2%
t	1525	0.1%
i	1098	0.1%
Other values (9)	4875	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1093178	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	536692	49.1%
n	532324	48.7%
r	4346	0.4%
f	3550	0.3%
s	2848	0.3%
d	2400	0.2%
h	1778	0.2%
z	1742	0.2%
t	1525	0.1%
i	1098	0.1%
Other values (9)	4875	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1093178	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	536692	49.1%
n	532324	48.7%
r	4346	0.4%
f	3550	0.3%
s	2848	0.3%
d	2400	0.2%
h	1778	0.2%
z	1742	0.2%
t	1525	0.1%
i	1098	0.1%
Other values (9)	4875	0.4%

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	364733
sem-brand	72210
sem-non-brand	47812
seo	23932
other	15603
Other values (3)	22299

Length

Max length	13
Median length	6
Mean length	6.80928449
Min length	3

Characters and Unicode

Total characters	3721880
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	seo
2nd row	direct
3rd row	direct
4th row	direct
5th row	other

Common Values

Value	Count	Frequency (%)
direct	364733	66.7%
sem-brand	72210	13.2%
sem-non-brand	47812	8.7%
seo	23932	4.4%
other	15603	2.9%
api	13812	2.5%
content	5642	1.0%
remarketing	2845	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
direct	364733	66.7%
sem-brand	72210	13.2%
sem-non-brand	47812	8.7%
seo	23932	4.4%
other	15603	2.9%
api	13812	2.5%
content	5642	1.0%
remarketing	2845	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	535622	14.4%
r	506048	13.6%
d	484755	13.0%
t	394465	10.6%
i	381390	10.2%
c	370375	10.0%
n	229775	6.2%
-	167834	4.5%
s	143954	3.9%
a	136679	3.7%
Other values (7)	370983	10.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3554046	95.5%
Dash Punctuation	167834	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	535622	15.1%
r	506048	14.2%
d	484755	13.6%
t	394465	11.1%
i	381390	10.7%
c	370375	10.4%
n	229775	6.5%
s	143954	4.1%
a	136679	3.8%
m	122867	3.5%
Other values (6)	248116	7.0%

Dash Punctuation

Value	Count	Frequency (%)
-	167834	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3554046	95.5%
Common	167834	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	535622	15.1%
r	506048	14.2%
d	484755	13.6%
t	394465	11.1%
i	381390	10.7%
c	370375	10.4%
n	229775	6.5%
s	143954	4.1%
a	136679	3.8%
m	122867	3.5%
Other values (6)	248116	7.0%

Common

Value	Count	Frequency (%)
-	167834	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3721880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	535622	14.4%
r	506048	13.6%
d	484755	13.0%
t	394465	10.6%
i	381390	10.2%
c	370375	10.0%
n	229775	6.2%
-	167834	4.5%
s	143954	3.9%
a	136679	3.7%
Other values (7)	370983	10.0%

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	363730
google	136487
other	22081
facebook	7048
craigslist	6073
Other values (12)	11170

Length

Max length	19
Median length	6
Mean length	6.050099801
Min length	3

Characters and Unicode

Total characters	3306918
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	google
2nd row	direct
3rd row	direct
4th row	direct
5th row	craigslist

Common Values

Value	Count	Frequency (%)
direct	363730	66.5%
google	136487	25.0%
other	22081	4.0%
facebook	7048	1.3%
craigslist	6073	1.1%
bing	5488	1.0%
facebook-open-graph	1616	0.3%
vast	1237	0.2%
padmapper	968	0.2%
yahoo	766	0.1%
Other values (7)	1095	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	363730	66.5%
google	136487	25.0%
other	22081	4.0%
facebook	7048	1.3%
craigslist	6073	1.1%
bing	5488	1.0%
facebook-open-graph	1616	0.3%
vast	1237	0.2%
padmapper	968	0.2%
yahoo	766	0.1%
Other values (7)	1095	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	534880	16.2%
r	394811	11.9%
t	393751	11.9%
i	381962	11.6%
c	378467	11.4%
d	364744	11.0%
o	315531	9.5%
g	286790	8.7%
l	142843	4.3%
h	24463	0.7%
Other values (14)	88676	2.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3303403	99.9%
Dash Punctuation	3515	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	534880	16.2%
r	394811	12.0%
t	393751	11.9%
i	381962	11.6%
c	378467	11.5%
d	364744	11.0%
o	315531	9.6%
g	286790	8.7%
l	142843	4.3%
h	24463	0.7%
Other values (13)	85161	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	3515	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3303403	99.9%
Common	3515	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	534880	16.2%
r	394811	12.0%
t	393751	11.9%
i	381962	11.6%
c	378467	11.5%
d	364744	11.0%
o	315531	9.6%
g	286790	8.7%
l	142843	4.3%
h	24463	0.7%
Other values (13)	85161	2.6%

Common

Value	Count	Frequency (%)
-	3515	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3306918	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	534880	16.2%
r	394811	11.9%
t	393751	11.9%
i	381962	11.6%
c	378467	11.4%
d	364744	11.0%
o	315531	9.5%
g	286790	8.7%
l	142843	4.3%
h	24463	0.7%
Other values (14)	88676	2.7%

first_affiliate_tracked
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

untracked	299592
linked	119529
omg	111004
tracked-other	12264
product	3839
Other values (2)	361

Length

Max length	13
Median length	9
Mean length	7.20114748
Min length	3

Characters and Unicode

Total characters	3936068
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	299592	54.8%
linked	119529	21.9%
omg	111004	20.3%
tracked-other	12264	2.2%
product	3839	0.7%
marketing	241	< 0.1%
local ops	120	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
untracked	299592	54.8%
linked	119529	21.9%
omg	111004	20.3%
tracked-other	12264	2.2%
product	3839	0.7%
marketing	241	< 0.1%
local	120	< 0.1%
ops	120	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	443890	11.3%
d	435224	11.1%
k	431626	11.0%
n	419362	10.7%
t	328200	8.3%
r	328200	8.3%
c	315815	8.0%
a	312217	7.9%
u	303431	7.7%
o	127347	3.2%
Other values (9)	490756	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3923684	99.7%
Dash Punctuation	12264	0.3%
Space Separator	120	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	443890	11.3%
d	435224	11.1%
k	431626	11.0%
n	419362	10.7%
t	328200	8.4%
r	328200	8.4%
c	315815	8.0%
a	312217	8.0%
u	303431	7.7%
o	127347	3.2%
Other values (7)	478372	12.2%

Dash Punctuation

Value	Count	Frequency (%)
-	12264	100.0%

Space Separator

Value	Count	Frequency (%)
	120	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3923684	99.7%
Common	12384	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	443890	11.3%
d	435224	11.1%
k	431626	11.0%
n	419362	10.7%
t	328200	8.4%
r	328200	8.4%
c	315815	8.0%
a	312217	8.0%
u	303431	7.7%
o	127347	3.2%
Other values (7)	478372	12.2%

Common

Value	Count	Frequency (%)
-	12264	99.0%
	120	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3936068	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	443890	11.3%
d	435224	11.1%
k	431626	11.0%
n	419362	10.7%
t	328200	8.3%
r	328200	8.3%
c	315815	8.0%
a	312217	7.9%
u	303431	7.7%
o	127347	3.2%
Other values (9)	490756	12.5%

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Web	505064
iOS	27965
Moweb	7774
Android	5786

Length

Max length	7
Median length	3
Mean length	3.070788106
Min length	3

Characters and Unicode

Total characters	1678459
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	505064	92.4%
iOS	27965	5.1%
Moweb	7774	1.4%
Android	5786	1.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
web	505064	92.4%
ios	27965	5.1%
moweb	7774	1.4%
android	5786	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	512838	30.6%
b	512838	30.6%
W	505064	30.1%
i	33751	2.0%
O	27965	1.7%
S	27965	1.7%
o	13560	0.8%
d	11572	0.7%
M	7774	0.5%
w	7774	0.5%
Other values (3)	17358	1.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1103905	65.8%
Uppercase Letter	574554	34.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	512838	46.5%
b	512838	46.5%
i	33751	3.1%
o	13560	1.2%
d	11572	1.0%
w	7774	0.7%
n	5786	0.5%
r	5786	0.5%

Uppercase Letter

Value	Count	Frequency (%)
W	505064	87.9%
O	27965	4.9%
S	27965	4.9%
M	7774	1.4%
A	5786	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1678459	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	512838	30.6%
b	512838	30.6%
W	505064	30.1%
i	33751	2.0%
O	27965	1.7%
S	27965	1.7%
o	13560	0.8%
d	11572	0.7%
M	7774	0.5%
w	7774	0.5%
Other values (3)	17358	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1678459	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	512838	30.6%
b	512838	30.6%
W	505064	30.1%
i	33751	2.0%
O	27965	1.7%
S	27965	1.7%
o	13560	0.8%
d	11572	0.7%
M	7774	0.5%
w	7774	0.5%
Other values (3)	17358	1.0%

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Mac Desktop	283506
Windows Desktop	181885
iPad	34461
iPhone	31707
Other/Unknown	5889
Other values (4)	9141

Length

Max length	18
Median length	11
Mean length	11.67294439
Min length	4

Characters and Unicode

Total characters	6380303
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Windows Desktop
3rd row	Mac Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	283506	51.9%
Windows Desktop	181885	33.3%
iPad	34461	6.3%
iPhone	31707	5.8%
Other/Unknown	5889	1.1%
Desktop (Other)	3489	0.6%
Android Phone	2952	0.5%
Android Tablet	2623	0.5%
SmartPhone (Other)	77	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
desktop	468880	45.9%
mac	283506	27.8%
windows	181885	17.8%
ipad	34461	3.4%
iphone	31707	3.1%
other/unknown	5889	0.6%
android	5575	0.5%
other	3566	0.3%
phone	2952	0.3%
tablet	2623	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	696965	10.9%
s	650765	10.2%
e	515694	8.1%
t	481035	7.5%
k	474769	7.4%
	474532	7.4%
D	468880	7.3%
p	468880	7.3%
a	320667	5.0%
M	283506	4.4%
Other values (20)	1544610	24.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4865663	76.3%
Uppercase Letter	1027087	16.1%
Space Separator	474532	7.4%
Other Punctuation	5889	0.1%
Open Punctuation	3566	0.1%
Close Punctuation	3566	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	696965	14.3%
s	650765	13.4%
e	515694	10.6%
t	481035	9.9%
k	474769	9.8%
p	468880	9.6%
a	320667	6.6%
c	283506	5.8%
i	253628	5.2%
n	239863	4.9%
Other values (7)	479891	9.9%

Uppercase Letter

Value	Count	Frequency (%)
D	468880	45.7%
M	283506	27.6%
W	181885	17.7%
P	69197	6.7%
O	9455	0.9%
U	5889	0.6%
A	5575	0.5%
T	2623	0.3%
S	77	< 0.1%

Space Separator

Value	Count	Frequency (%)
	474532	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	5889	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3566	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3566	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5892750	92.4%
Common	487553	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	696965	11.8%
s	650765	11.0%
e	515694	8.8%
t	481035	8.2%
k	474769	8.1%
D	468880	8.0%
p	468880	8.0%
a	320667	5.4%
M	283506	4.8%
c	283506	4.8%
Other values (16)	1248083	21.2%

Common

Value	Count	Frequency (%)
	474532	97.3%
/	5889	1.2%
(	3566	0.7%
)	3566	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6380303	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	696965	10.9%
s	650765	10.2%
e	515694	8.1%
t	481035	7.5%
k	474769	7.4%
	474532	7.4%
D	468880	7.3%
p	468880	7.3%
a	320667	5.0%
M	283506	4.4%
Other values (20)	1544610	24.2%

first_browser
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Chrome	191033
Safari	134561
Firefox	98407
IE	45387
Mobile Safari	41623
Other values (36)	35578

Length

Max length	18
Median length	6
Mean length	6.602147134
Min length	2

Characters and Unicode

Total characters	3608661
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	IE
3rd row	Firefox
4th row	Chrome
5th row	Safari

Common Values

Value	Count	Frequency (%)
Chrome	191033	35.0%
Safari	134561	24.6%
Firefox	98407	18.0%
IE	45387	8.3%
Mobile Safari	41623	7.6%
-unknown-	30549	5.6%
Chrome Mobile	2105	0.4%
Android Browser	1126	0.2%
Opera	402	0.1%
AOL Explorer	294	0.1%
Other values (31)	1102	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	193138	32.6%
safari	176184	29.8%
firefox	98450	16.6%
ie	45400	7.7%
mobile	43786	7.4%
unknown	30549	5.2%
browser	1229	0.2%
android	1126	0.2%
opera	406	0.1%
explorer	314	0.1%
Other values (33)	1452	0.2%

Most occurring characters

Value	Count	Frequency (%)
r	472896	13.1%
o	369409	10.2%
a	353145	9.8%
e	337923	9.4%
i	320119	8.9%
f	274634	7.6%
m	193616	5.4%
h	193441	5.4%
C	193424	5.4%
S	176438	4.9%
Other values (36)	723616	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2894250	80.2%
Uppercase Letter	607855	16.8%
Dash Punctuation	61098	1.7%
Space Separator	45445	1.3%
Other Punctuation	13	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	472896	16.3%
o	369409	12.8%
a	353145	12.2%
e	337923	11.7%
i	320119	11.1%
f	274634	9.5%
m	193616	6.7%
h	193441	6.7%
x	98844	3.4%
n	93004	3.2%
Other values (14)	187219	6.5%

Uppercase Letter

Value	Count	Frequency (%)
C	193424	31.8%
S	176438	29.0%
F	98470	16.2%
E	45714	7.5%
I	45516	7.5%
M	44095	7.3%
A	1537	0.3%
B	1390	0.2%
O	702	0.1%
L	294	< 0.1%
Other values (9)	275	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	61098	100.0%

Space Separator

Value	Count	Frequency (%)
	45445	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3502105	97.0%
Common	106556	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	472896	13.5%
o	369409	10.5%
a	353145	10.1%
e	337923	9.6%
i	320119	9.1%
f	274634	7.8%
m	193616	5.5%
h	193441	5.5%
C	193424	5.5%
S	176438	5.0%
Other values (33)	617060	17.6%

Common

Value	Count	Frequency (%)
-	61098	57.3%
	45445	42.6%
.	13	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3608661	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	472896	13.1%
o	369409	10.2%
a	353145	9.8%
e	337923	9.4%
i	320119	8.9%
f	274634	7.6%
m	193616	5.4%
h	193441	5.4%
C	193424	5.4%
S	176438	4.9%
Other values (36)	723616	20.1%

country_destination
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

NDF	54850
GB	52706
ES	50512
US	47693
NL	47593
Other values (7)	293235

Length

Max length	5
Median length	2
Mean length	2.346369942
Min length	2

Characters and Unicode

Total characters	1282500
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	US
3rd row	other
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	54850	10.0%
GB	52706	9.6%
ES	50512	9.2%
US	47693	8.7%
NL	47593	8.7%
PT	47100	8.6%
other	44824	8.2%
FR	43911	8.0%
CA	42544	7.8%
IT	40213	7.4%
Other values (2)	74643	13.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	54850	10.0%
gb	52706	9.6%
es	50512	9.2%
us	47693	8.7%
nl	47593	8.7%
pt	47100	8.6%
other	44824	8.2%
fr	43911	8.0%
ca	42544	7.8%
it	40213	7.4%
Other values (2)	74643	13.7%

Most occurring characters

Value	Count	Frequency (%)
N	102443	8.0%
F	98761	7.7%
S	98205	7.7%
D	92689	7.2%
E	88351	6.9%
T	87313	6.8%
U	84497	6.6%
A	79348	6.2%
B	52706	4.1%
G	52706	4.1%
Other values (10)	445481	34.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1058380	82.5%
Lowercase Letter	224120	17.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	102443	9.7%
F	98761	9.3%
S	98205	9.3%
D	92689	8.8%
E	88351	8.3%
T	87313	8.2%
U	84497	8.0%
A	79348	7.5%
B	52706	5.0%
G	52706	5.0%
Other values (5)	221361	20.9%

Lowercase Letter

Value	Count	Frequency (%)
o	44824	20.0%
t	44824	20.0%
h	44824	20.0%
e	44824	20.0%
r	44824	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1282500	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	102443	8.0%
F	98761	7.7%
S	98205	7.7%
D	92689	7.2%
E	88351	6.9%
T	87313	6.8%
U	84497	6.6%
A	79348	6.2%
B	52706	4.1%
G	52706	4.1%
Other values (10)	445481	34.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1282500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	102443	8.0%
F	98761	7.7%
S	98205	7.7%
D	92689	7.2%
E	88351	6.9%
T	87313	6.8%
U	84497	6.6%
A	79348	6.2%
B	52706	4.1%
G	52706	4.1%
Other values (10)	445481	34.7%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	signup_flow	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
0	0	2228	732	1496	2009	5	23	5	21	2015	6	29	0	27	2011	5	25	2	21	MALE	38	facebook	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF
1	3	419	476	-57	2009	6	9	1	24	2010	8	2	0	31	2010	9	28	1	39	FEMALE	56	basic	en	direct	direct	untracked	Web	Windows Desktop	IE	US
2	0	1043	765	278	2009	10	31	5	44	2012	9	8	5	36	2011	12	5	0	49	FEMALE	42	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other
3	0	72	280	-208	2009	12	8	1	50	2010	2	18	3	7	2010	9	14	1	37	-unknown-	41	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	US
4	0	3	0	3	2010	1	2	5	53	2010	1	5	1	1	2010	1	2	5	53	FEMALE	46	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
5	0	10	0	10	2010	1	3	6	53	2010	1	13	2	2	2010	1	3	6	53	FEMALE	47	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	US
6	0	206	0	206	2010	1	4	0	1	2010	7	29	3	30	2010	1	4	0	1	FEMALE	50	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
7	0	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1	-unknown-	46	basic	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US
8	0	2	0	2	2010	1	4	0	1	2010	1	6	2	1	2010	1	4	0	1	FEMALE	36	basic	en	other	craigslist	untracked	Web	Mac Desktop	Firefox	US
9	0	2001	0	2001	2010	1	5	1	1	2015	6	29	0	27	2010	1	5	1	1	FEMALE	47	basic	en	other	craigslist	untracked	Web	iPhone	-unknown-	NDF

Last rows

	signup_flow	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
546579	0	1	1	2013	12	17	1	51	2013	12	18	2	51	2013	12	17	1	51	MALE	31	facebook	en	direct	direct	linked	Web	Mac Desktop	Safari	other
546580	20	73	73	2014	2	5	2	8	2014	4	18	5	18	2014	2	5	2	8	FEMALE	30	basic	en	direct	direct	untracked	iOS	Mac Desktop	Chrome	other
546581	0	0	0	2013	11	19	1	47	2013	11	19	1	47	2013	11	19	1	47	MALE	24	basic	zh	direct	direct	linked	Web	Windows Desktop	Chrome	other
546582	0	1	1	2013	10	1	1	40	2013	10	2	2	40	2013	10	1	1	40	FEMALE	41	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	other
546583	0	1	1	2013	3	21	3	12	2013	3	22	4	12	2013	3	21	3	12	FEMALE	33	basic	en	direct	direct	linked	Web	Mac Desktop	Firefox	other
546584	0	0	0	2013	4	21	0	17	2013	4	21	0	17	2013	4	21	0	17	-unknown-	41	basic	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	other
546585	0	55	55	2012	7	2	0	27	2012	8	26	5	34	2012	7	2	0	27	MALE	28	facebook	en	sem-brand	google	omg	Web	Mac Desktop	Chrome	other
546586	0	22	22	2014	5	21	2	21	2014	6	12	3	24	2014	5	21	2	21	-unknown-	30	basic	en	direct	direct	untracked	Web	Windows Desktop	IE	other
546587	0	2	2	2014	1	13	0	3	2014	1	15	2	3	2014	1	13	0	3	FEMALE	30	basic	en	direct	direct	linked	Web	Mac Desktop	Safari	other
546588	0	1	1	2012	7	20	5	29	2012	7	22	0	30	2012	7	20	5	29	MALE	25	facebook	en	direct	direct	untracked	Web	Windows Desktop	Chrome	other

Most frequently occurring

	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	# duplicates
7627	2013	6	6	3	23	2013	6	6	3	23	2013	6	6	3	23	FEMALE	25	basic	en	direct	direct	untracked	Web	Mac Desktop	Safari	PT	128
833	2012	3	1	2	9	2012	3	1	2	9	2012	3	1	2	9	FEMALE	40	basic	en	sem-brand	google	linked	Web	Mac Desktop	Firefox	PT	127
7911	2013	6	15	5	24	2013	6	15	5	24	2013	6	15	5	24	FEMALE	31	facebook	en	direct	direct	untracked	Web	Windows Desktop	Chrome	PT	122
4620	2013	1	25	4	4	2013	1	25	5	4	2013	1	25	4	4	FEMALE	25	facebook	en	direct	direct	linked	Web	Mac Desktop	Safari	PT	108
13192	2014	6	23	0	26	2014	6	23	0	26	2014	6	23	0	26	FEMALE	21	facebook	en	seo	facebook	untracked	Web	Mac Desktop	Chrome	PT	97
7555	2013	6	3	1	23	2013	6	3	1	23	2013	6	3	1	23	FEMALE	19	basic	en	direct	direct	untracked	Web	Mac Desktop	Safari	PT	96
8365	2013	6	27	3	26	2013	6	27	3	26	2013	6	27	3	26	FEMALE	45	basic	en	sem-non-brand	google	omg	Web	Windows Desktop	IE	PT	96
5400	2013	3	3	0	10	2013	3	3	0	10	2013	3	3	0	10	-unknown-	35	basic	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	PT	95
1810	2012	6	19	1	25	2012	6	19	1	25	2012	6	19	1	25	FEMALE	37	facebook	en	direct	direct	omg	Web	Mac Desktop	Safari	PT	92
5476	2013	3	5	1	10	2013	3	5	1	10	2013	3	5	1	10	MALE	25	facebook	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	PT	86

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script